USE [WarehouseManagement]
GO

/****** Object:  StoredProcedure [dbo].[GetSingleMaterial]    Script Date: 03/14/2011 23:51:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		duylv00360
-- Create date: 3/14/2011
-- Description:	This stored procedure use to get specific material
-- =============================================
CREATE PROCEDURE [dbo].[GetSingleMaterial] 
	-- Add the parameters for the stored procedure here
	@materialID int = 0
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT 
			[MaterialID]
			, [MaterialCode]
			, [MaterialName]
			, [Description]
			, [isDelete]
	FROM 
			[Material]
	WHERE 
			MaterialID = @materialID
	
END

GO

USE WarehouseManagement
GO

EXEC GetSingleMaterial
